Q($sql); while($DBR = $DB->Fetch_key()) { $post_year = substr($DBR['post_date'],0,4); $all_years[$post_year] = $post_year; } // 記事 の ID を 取得 -------------------------------------------- if(isset($_GET["id"]) && strlen($_GET["id"]) <= 5 && preg_match("/^[0-9]+$/",$_GET["id"])) { $get_id = $_GET["id"]; // 記事取得 $sql = "SELECT `post_status`,`post_date`,`post_title`,`post_content` FROM `wp_baby_posts` WHERE `ID` = $get_id LIMIT 1"; $DB->Q($sql); $post_data = $DB->Fetch_key(); // 公開ステータス確認 if($post_data["post_status"] == "publish" || $post_data["post_status"] == "future") // 公開OK ------------------------------------- { // 記事 と カテゴリ の 関係を紐づける -------------------------------------------- $sql = "SELECT `object_id`,`term_taxonomy_id` FROM `wp_baby_term_relationships` WHERE `object_id` = $get_id ORDER BY `term_taxonomy_id`"; $DB->Q($sql); while($DBR = $DB->Fetch_key()) { $post_data['term_id'][$DBR["term_taxonomy_id"]] = NULL; } // アイキャッチ画像 $sql = "SELECT `meta_value` FROM `wp_baby_postmeta` WHERE `post_id` = $get_id AND `meta_key` = '_thumbnail_id' LIMIT 1"; $DB->Q($sql); if($DBR = $DB->Fetch_key()) { // 画像 を 取得 $image_id = $DBR['meta_value']; $sql = "SELECT `ID`,`post_title`,`guid` FROM `wp_baby_posts` WHERE `ID` = '$image_id'"; $DB->Q($sql); $DBR = $DB->Fetch_key(); $post_data['thumbnail'] = $DBR['guid']; } } $post_data['post_date'] = preg_replace("/\-/",".",substr($post_data['post_date'],0,10)); $post_data['post_year'] = substr($post_data['post_date'],0,4); $page["name"] = $post_data['post_year']." News & Topics"; } else { // 引数 が ミスっていたら 一覧 へ リダイレクト header("Location: news_topics.php"); exit; } ?> <?=$html_header["site_name"];?>|<?=$page["name"];?>|<?=$post_data['post_title'];?>
TOP    

$categoryV) { if($categoryK == "1") { ?>